/*
 Navicat Premium Dump SQL

 Source Server         : sqlserver11
 Source Server Type    : SQL Server
 Source Server Version : 16001000 (16.00.1000)
 Source Host           : WANG\SQLEXPRESS:1433
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000 (16.00.1000)
 File Encoding         : 65001

 Date: 11/12/2024 15:58:46
*/


-- ----------------------------
-- Table structure for 复试登记表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[复试登记表]') AND type IN ('U'))
	DROP TABLE [dbo].[复试登记表]
GO

CREATE TABLE [dbo].[复试登记表] (
  [examnumber] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [subjectid] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [subjectname] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [gender] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [undergradschool] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [undergradmajor] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [graduationtime] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [phone] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [emergencyphone] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [signature] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [stu_type] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [category] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [preferred_mentor_1] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [preferred_mentor_2] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [preferred_mentor_3] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [research_direction] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [accept_adjustment] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [adjustment_order_1] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [adjustment_order_2] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [adjustment_order_3] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [adjustment_order_4] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [retesttimeplace] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [evaluation] text COLLATE Chinese_PRC_CI_AS  NULL,
  [leadersignature] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [foreignlanguage] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [knowledgetest] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [interview] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [totalscore] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [membersignature] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [mentorsignature] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [state] varchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL
)
GO

ALTER TABLE [dbo].[复试登记表] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of 复试登记表
-- ----------------------------
INSERT INTO [dbo].[复试登记表] ([examnumber], [subjectid], [subjectname], [name], [gender], [undergradschool], [undergradmajor], [graduationtime], [phone], [emergencyphone], [signature], [stu_type], [category], [preferred_mentor_1], [preferred_mentor_2], [preferred_mentor_3], [research_direction], [accept_adjustment], [adjustment_order_1], [adjustment_order_2], [adjustment_order_3], [adjustment_order_4], [retesttimeplace], [evaluation], [leadersignature], [foreignlanguage], [knowledgetest], [interview], [totalscore], [membersignature], [mentorsignature], [state]) VALUES (N'001', N'081200', N'计算机科学与技术', N'张三', N'男', N'11', N'1', N'1', N'13821071278', N'13821071278', NULL, N'同等学力', N'非定向考生', N'西门子轩', N'上官浩宇', N'司马睿辰', N'1', N'', N'', N'', N'', N'', N'2024年11月17日20:37:55 西配楼', N'好', N'111', N'1', N'1', N'1', N'1', N'111', NULL, N'1')
GO

INSERT INTO [dbo].[复试登记表] ([examnumber], [subjectid], [subjectname], [name], [gender], [undergradschool], [undergradmajor], [graduationtime], [phone], [emergencyphone], [signature], [stu_type], [category], [preferred_mentor_1], [preferred_mentor_2], [preferred_mentor_3], [research_direction], [accept_adjustment], [adjustment_order_1], [adjustment_order_2], [adjustment_order_3], [adjustment_order_4], [retesttimeplace], [evaluation], [leadersignature], [foreignlanguage], [knowledgetest], [interview], [totalscore], [membersignature], [mentorsignature], [state]) VALUES (N'002', N'081200', N'计算机科学与技术', N'李四', N'男', N'上海交通大学', N'网络工程', N'2024-6-7', N'13800138002', N'13800131114', NULL, N'应届生', N'定向生', N'司马睿辰', N'西门子轩', N'南宫晓晨', N'计算机科学与技术', N'', N'', N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO


-- ----------------------------
-- Primary Key structure for table 复试登记表
-- ----------------------------
ALTER TABLE [dbo].[复试登记表] ADD CONSTRAINT [PK_复试登记表] PRIMARY KEY CLUSTERED ([examnumber])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

